<?php
/**
 * User: lukas
 * Date: 12/5/12
 * Time: 11:41 AM
 */
class DataBaseStructure
{
    public static $TABLE_USER ="t_user";
    public static $TABLE_USER2PROJECT = "t_user2project";
    public static $TABLE_PROJECT = "t_project";
    public static $TABLE_TASK = "t_task";
    public static $TABLE_TASK2PROJECT = "t_task2project";
    public static $TABLE_SUBTASK = "t_subtask";
    public static $TABLE_SUBTASK2TASK = "t_subtask2project";

    public static $USER_COLUMN_ID = "id";
    public static $USER_COLUMN_NAME = "name";
    public static $USER_COLUMN_EMAIL = "email";
    public static $USER_COLUMN_PASSWORD = "password";

    public static $PROJECT_COLUMN_ID = "id";
    public static $PROJECT_COLUMN_NAME = "name";
    public static $PROJECT_COLUMN_DESCRIPTION = "description";
    public static $PROJECT_COLUMN_PROGRESS = "progress";

    public static $USER2PROJECT_COLUMN_ID = "id";
    public static $USER2PROJECT_COLUMN_PROJECT_ID = "project_id";
    public static $USER2PROJECT_COLUMN_USER_ID = "user_id";

    public static $TASK_COLUMN_ID = "id";
    public static $TASK_COLUMN_NAME = "name";
    public static $TASK_COLUMN_DESCRIPTION = "description";
    public static $TASK_COLUMN_STATUS = "status";
    public static $TASK_COLUMN_PROJECT_ID = "project_id";

    public static $TASK2PROJECT_COLUMN_ID = "id";
    public static $TASK2PROJECT_COLUMN_TASK_ID = "task_id";
    public static $TASK2PROJECT_COLUMN_PROJECT_ID = "project_id";

    public static $SUBTASK_COLUMN_ID = "id";
    public static $SUBTASK_COLUMN_NAME = "name";
    public static $SUBTASK_COLUMN_DESCRIPTION = "description";
    public static $SUBTASK_COLUMN_STATUS = "status";
    public static $SUBTASK_COLUMN_TASK_ID = "task_id";

    public static $SUBTASK2TASK_COLUMN_ID = "id";
    public static $SUBTASK2TASK_COLUMN_TASK_ID = "task_id";
    public static $SUBTASK2TASK_COLUMN_SUBTASK_ID = "subtask_id";


}
